SQL Test Panel
Overview
The SQL Test Panel is included under the HighStone System Administration Menu. The panel allows the entry of valid SQL Scripts which may then be used to view the results of a SELECT Query, or a functional SQL Command may be executed.
An understanding of the SQL Scripting Language is required in order to use the panel. Access is usually controlled to limited number of User Classes. HighStone allows the permissions to be set such that some User Classes may be granted the 'View' facility based on the SELECT SQL statement syntax, whilst disallowing the functional SQL Commands such as UPDATE, DELETE etc.
Users must be aware that HighStone applies no validation or warnings on the use of this panel display. Functional SQL Commands are submitted and, if valid to the Database, will be executed without further ado. Destructive commands such as DELETE, DROP etc are applied with no further warning check - and once applied cannot be undone.
HighStone does disable any Database Commands that will be interpreted as Operating System commands by the host Database.
Using SQL Test Panel